{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3","Sheet9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name",null," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID",null," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-02-12T12:53:41.980"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class."]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.0"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Windows (64-bit) NT 10.00"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!"]
["Action","Name","Panther ID","Date/Time"]
["Starter Sheet","None",0,"2020-01-01"]

{"sheet":"Financial information ","index":2,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":true,"merged":[[36,1,36,2]]}
["Donut Information "]
["Based on the below data, create the profit model for Donuts to Go."]
["Assume that each customer will buy one donut and one cup of coffee"]
[" "]
[null,null,null,null,null,"Enter totals "]
[null,"Time period",null,null,"Fixed Costs"]
["Revenue: Cup of Coffee",null,4,null,"Varible Costs"]
["Revenue: Donut"," ",3.5,null,"Coffee"]
["Donut ingredients per donunt)","per donut",0.5,null,"Donut"]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000,null,null,null,null,null," "]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200," "]
[" ",null," "]
[]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
["Month","Demand","Yearly average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
["2018-01-01",null,null,null,null,null,null,null,"CLICK CELL J2 as output cell for regression"]
["2018-02-01"]
["2018-03-01"]
["2018-04-01"]
["2018-05-01"]
["2018-06-01"]
["2018-07-01"]
["2018-08-01"]
["2018-09-01"]
["2018-10-01"]
["2018-11-01",null,"Put yearly average in below cell "]
["2018-12-01"]
["2019-01-01"]
["2019-02-01"]
["2019-03-01"]
["2019-04-01"]
["2019-05-01"]
["2019-06-01"]
["2019-07-01"]
["2019-08-01"]
["2019-09-01",null,null,null,null," "]
["2019-10-01"]
["2019-11-01",null,"Put yearly average in below cell "]
["2019-12-01"]
["2020-01-01"]
["2020-02-01"]
["2020-03-01"]
["2020-04-01"]
["2020-05-01"]
["2020-06-01"]
["2020-07-01"]
["2020-08-01"]
["2020-09-01"]
["2020-10-01"]
["2020-11-01",null,"Put yearly average in below cell ",null,null,null,null,null,"Use the average seasonal Index  in the column for year 2018"]
["2020-12-01",null,null,null,null,null,null,"Deseasonalized forecast","Seasonalized forecast"]
[null,null,null,null,null,null,null,null,null,"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":75,"n_cols":26,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2"]
["AVERAGE DEMAND"]
["Month "]
["Demand",null,null,null,null,null,null,null,null,null,null,null," "]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]

{"sheet":"Expected Values Pt3","index":6,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":true,"merged":[[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[]
[]
[null,null,null,null,null,null,null,"Decision Alternatives"]
[null,"DM UNDER IGNORANCE"]
[null,null,null,null,null,null,null,"Kiana should choose to:"]
[null,"Maximin"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,"Because:"]
[]
[]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[null,"EVPI"]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]

{"sheet":"Sheet9","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}